select A.Name as [Table],SUBSTRING(B.Properties,CHARINDEX('ReceiverName=', B.Properties)+13,10) As ReceiverName 
from  DBMMReplications as A join DBMMReplStatuses as B 
            on A.ReplicationID=B.ReplicationID where B.Properties LIKE '%ReceiverName%'
            order by ReceiverName
